/*
 * Copyright 2023-2085 xujin <ceo@itgrail.com>
 *
 * Licensed under the Grail License, Version 1.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * https://itgrail.com/docs?id=3&catalogId=87
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.itgrail.pilot.infrastructure.tunnel.db.dao;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itgrail.pilot.infrastructure.tunnel.db.dataobject.UserRolesDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.stream.Collectors;

@Mapper
public interface UserRolesMapper extends BaseMapper<UserRolesDO> {

    /**
     * 查找用户的角色列表
     *
     * @param userName
     * @return user roleList
     */
    public default List<String> findUserRoles(String userName) {
        QueryWrapper<UserRolesDO> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("username", userName);
        queryWrapper.eq("is_deleted", 0);
        List<UserRolesDO> userRolesDOs = selectList(queryWrapper);
        return userRolesDOs.stream().map(UserRolesDO::getRole).collect(Collectors.toList());
    }

    @Select("select * from t_user_roles where is_deleted=0 and role=#{role} ")
    List<UserRolesDO> queryByRole(String role);

    @Select("select * from t_user_roles where is_deleted=0 and username=#{username} ")
    UserRolesDO queryByUserName(String username);

    @Select("select * from t_user_roles where is_deleted=0 and username=#{username} and role=#{role}")
    UserRolesDO queryByUserNameAndRole(String username,String role);


}
